set hive.exec.dynamic.partition=true;            --  动态分区
set hive.exec.dynamic.partition.mode=nonstrict;
set hive.exec.max.dynamic.partitions=100;         --  每天生成 60 个分区
set hive.exec.max.dynamic.partitions.pernode=100; --  每天生成 60 个分区

insert overwrite table jms_dim.dim_lmdm_sys_user
select id
     , staff_no
     , name
     , en_name
     , cn_name
     , sex
     , user_type
     , network_id
     , network_name
     , dept_id
     , dept_name
     , post_id
     , post_name
     , mobile
     , email
     , is_initialization
     , app_is_initialization
     , phone
     , remark
     , password
     , app_password
     , mac_addr
     , config_color
     , config_language
     , is_enable
     , is_delete
     , create_by
     , update_by
     , create_by_name
     , update_by_name
     , create_time
     , update_time
     , version
     , sort
     , dept_level_id
     , network_code
     , dept_level_name
     , site_login_flag
     , password_salt
     , post_code
     , pc_login_device
     , update_password_time
     , last_login_time
     , incumbency_status
     , alert_msg
     , msg_audio
     , position
from jms_ods.yl_lmdm_sys_user
where  dt = '{{ execution_date | cst_ds }}';